Lookup Match assistance

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

example
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"

Wadafruck,

I think this might be what your looking for. Let me know if I got it wrong and I will see what I can do to fix it!


Simeon

Originally Posted by simeon.hruby

Wadafruck,

I think this might be what your looking for. Let me know if I got it wrong and I will see what I can do to fix it!


Simeon

not quite, but it got me close enough that I could fiddle with it and figure it out from here! Thanks a ton!
=IFERROR(INDEX('QB INPUT'!$D$2:$L$30000,MATCH(Calculations!A3,'QB INPUT'!$D$2:$D$30000,0),9),"")

Glad I could help!

Don't hesitate to ask if you need anything else!


Simeon