=IF VLOOKUP Question

[Frank Kabel]

Hi
what do you mean with 'does not work'. The formula looks o.k. (should
return the value form column D of your 'list' worksheet).

 

[Frank Kabel]

Hi
the #NA error indicated that the value from cell C8 is not fount within
the lookup range on your other sheet. Have you checked that the value
from C8 exists on the other sheet?

 

[SlimPickins]

This one works
=IF(G8<>"",VLOOKUP(G8,List!$B$1:$Y$100,21,0),"")

This one does not
=IF(C8<>"",VLOOKUP(C8,List!$B$1:$Y$100,3,0),"")

the 3 and 21 are columns
at the present time I have 630 rows on this worksheet
C8 is a cell that I called "Listing Number:" on my "List" sheet I
created a new column - the rows are numbered from 1 - 630 when C8 is
filled with a given number all the cells with the above formula will
fill with information.

Frank Kabal helped with the working formula but there are some dates
that have more one entry, that is why I made the C8 cell.

Slim

 

[SlimPickins]

It does not compute......
I know it shoul work because your formula worked like a champ.
All I did was replace C8 for G8 in the formula. My formula returns
#N/A

Thanks for all you help and patience, Frank.

Slim

 

[SlimPickins]

I double checked column numbers, had an error.
It's working now.

Thanks
Slim