Cloud Computing Insider Awards 2022: Vote for ONLYOFFICE
Vote for ONLYOFFICE

Changing "Lookup Value" in Lookup Functions

I have a formula in which I want to change the Lookup value from, in the example, A3 to A4, but not the rest of the formula. Is there a way to do this currently? I would like something I can populate along the length of what I have available in my “A” cells, i.e. I can drag or copy/paste the formula and only the Lookup value changes.

=HLOOKUP(A3,Data!B1:BF2,2,Data!B2:BF2)

Hello @OfficeUser
If it’s possible, please provide us with file example and detailed description of the situation (you can make screenshots or videofile).

image

As described, what I want to do is only change the lookup value in the first section. So if we break down the argument, I’m only wanting to change the value of the first section.
Not sure why a picture is required.
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

As far as I understand your scenario, you are going to copy the formula to another sheets\files and you are looking for the way to replace some values quickly (from A column in your example).
Unfortunately, I’m not sure that there’s any way except manual changing data in formula bar.
Please clarify if I misunderstood your scenario.