Share via

How to use formulas in excel when exporting data using forms?

Alix Jenevizian 0 Reputation points
2023-01-16T15:26:45.68+00:00

The formula I am using is

=IF(COUNTBLANK(B12)=0, VLOOKUP(B12,lookupTab,2,0), "")

It all works perfectly UNTIL I submit a new answer on the forms then the cells shift when new information is added and therefore it doesn't correctly give the answer.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,736 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 24,131 Reputation points Microsoft Vendor
    2023-01-17T02:38:31.9866667+00:00

    Hi @Alix Jenevizian,

    Did the "lookupTab" table is fixed? Or you need to add more data into the "lookupTab" table?

    Try to use the absolute reference in the formula: https://www.excelmojo.com/absolute-reference-in-excel/

    Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

    I also suggest you be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments