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
Bookmarks