New
#1
find contents of ajoining cell
Hi all,,, I have a single column array and using vlookup to get a cell, and I need to know what the cell above it contains. Can you help please.
Len
Hi all,,, I have a single column array and using vlookup to get a cell, and I need to know what the cell above it contains. Can you help please.
Len
Easiest way is to copy the single column next to it but one row down
e.g.
Vlookup has to cover range of both columns, then use colum index as 2.Code:A BA CB DC D
Thanks very much,,,that works for me.
Len