I am a bit confused with lookup/match and the lookup wizard in excel 07 does not seem to allow multiple sheets properly.
What I need is for cell B2:BXXXX on Sheet 2 to run the following and display the answer compare Cell A2:AXXXX on sheet 2 to the values on D2:D30000 on sheet 3, finding the exact match only if exact match is found, return the entire contents of Cell L2:L30000 on sheet 3 where the row is the matching row from D2:D30000 If no match is found, return #N/A is fine
Sheet 2 90336-N 32(formula is here) 90336-R #N/A (formula is copy down'ed this entire column)
D L 90336-N 32 90336 12 90336-Q 8
any help? - the entire sheet has alot of financial data as well as company databases that I cannot post, the data above is just simply some "fluff"