Thread: Lookup??

I am trying to find "Question Eight", "Question Nine", and "Interest" in a column that grows with data. I am having trouble using a vlookup to retreive the answers to these questions once the data has changed and there cell ref has moved. Can anyone please help with a lookup so that I can find these in a list of updated data.

Many thanks

To get the row number of the first instance of a specific entry try a formula like this:

=MATCH("Interest",A:A,0)

assuming you know the data is in column A

Thanks daddylonglegs.

What I need though is where any of the criteria are found in column A to return the value in column D. Will this work for this?

If you want to find the first instance of "Interest" in column A and then return the value from D you can use VLOOKUP, i.e.

=VLOOKUP("Interest",A:D,4,0)

...or do you have multiple matches with "Interest"?