Guru as I am, I have been tasked with solving something, and I can't!
There is a sheet that requires look-up table values in a column.
It is in this format...
Col A - Col B - Vlookup()
The sheet the data for Column Vlookup() is in is in the format...
Col A - Col B - Col C
Column A holds the value I wish to put into the third column of the first sheet.
HOWEVER!
Whilst normally this would be easy, in this case I need to use 2 columns for the look up and the compare.
How?
I have tried Vlookup(A1&B1,[Datatable],1,T) but it doesn't work.