stuck with VLOOKUP

  • Thread starter Thread starter yimcw
  • Start date Start date
Y

yimcw

hi, aladin,
thks for the tips, but sounds complicated to me, is there a simpler
method. i chek some of the old files which uses this same formula but
dun have such problem, but the guy who created this files had left long
ago.

i am still... :confused:
 
yimcw said:
hi, aladin,
thks for the tips, but sounds complicated to me, is there a simple
method. i chek some of the old files which uses this same formula bu
dun have such problem, but the guy who created this files had left lon
ago.

i am still... :confused:
Click to expand...

=IF(ISNA(VLOOKUP($H12,SLOW,2,0)),0,VLOOKUP($H12,SLOW,2,0))

0 has the same meaning/effect as FALSE
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup - picking from a formula. 2
Another Vlookup for VBA question 4
Excel Vlookup Help 0
stuck with VLOOKUP 1
The death of music TV channels in UK - but not Europe? 4
vlookup on different sheet/tab based on stored variable 2
Using Vlookup function to solve the below problem 1
Vlookup Calculation from another Excel file 4

Back
Top