In your VLOOKUP, you are searching for 10251 in column A (A1:A6) and returning a matching value. In this instance, the matching value can only really be in column B ... though you could return the search value from column A. X1 would determine which column to return from the matrix so, in this instance, I don't think it will do what you want.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks for replying! Okay, so it appears that the Index value is hard coded into the formula and can't be a variable.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks