Hi

I can preform normal Hlookup but this time have small issue.

I have 2 file.

in one file i have date running with data below (example below)

20/9/2011 21/9/11 22/9/11 23/9/11 24/9/11 25/9/11 26/9/11 20/9/11 27/9/11
sun mon tue wed thur fri sat sun
12 23 45 56 34 22 11 3434


currently my hllokup the date 20/9/11 and brings over the value 12 BUT i don't want this value i want 3434 (coloured in red) 7 column along with same date.

can someone help