=IF VLOOKUP Question

F

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).
 
F

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?
 
S

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
 
S

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
 
Top