can VLOOKUP handle this? Should be simple but not for me

N

NoviceUser

I have 2 works sheets (PRNCATG and NASD 05)

PRNCATG contains Col A (cat numbers) along with other info in other cols
NASD 05 contains Col A (mainly the same set of catalog numbers as in PRNCATG
Col A with multiple new items) and Col B (05 prices)

I copied and pasted the formula below to bring in the 05 prices
=VLOOKUP('NASD 05'!A5,'NASD 05'!A5:B5,2,FALSE)

This works fine until there is a row containing a new catalog number in
NASD05, thus causing all the other info below to be off. Example:
on row 29 of PRNCATG the price being calculated/brought in is not the
correct one for that catalog number although it is correct for a row a couple
rows done

I think I might need to INDEX and MATCH functions but am feeling Very lost.
Do I need to do something else?

Can anyone help?
 
F

Frank Kabel

Hi
uise VLOOKUP in the following way:
=VLOOKUP('NASD 05'!A5,'NASD 05'!$A$1:$B$1000,2,FALSE)
and copy this down
 
F

Fiona O'Grady

Have you tried

=VLOOKUP('NASD 05'!A5,'NASD 05'!A:B,2,FALSE)

I think that might work.

Fiona
 
Top