Hi all,
A quick question...
Is it possible to use a VLOOKUP (or HLOOKUP), to check if any one reference number in a row of reference numbers is present in another column of reference numbers.
Then, if it is, find this particular reference number in the vertical list, and pull out the value associated with that number (in a column immediately to the right of the reference numbers)
I hope this makes sense.
If I had the data on my person, I would upload a screenshot, unfortunately, I don't, sorry.
Thanks for the help
Bookmarks