=IF(ISERROR(VLOOKUP($C109,D!$C$5:$C$75,1,FALSE)),0,1) what's D!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:

I would like to know what does the D! stand for? if the range of cells is
where VLOOK NEED TO LOOK UP what is the D!?

Thank you,
 
Looks like a typo to me. Probably should be a one (1) and not shift+1 which
would give you "!".

Regards,
Paul
 
=IF(ISERROR(VLOOKUP($C109,D!$C$5:$C$75,1,FALSE)),0,1) what's D!

It's the name of the worksheet tab where $C$5:$C$75 is found.
 
"D" is the sheet name.

The "!" character is the sheet name identifier. It lets Excel know that what
preceds it is a sheet name.

Sheet1!
Sales!
August 2007!
Summary!
 
Oops. I missed that it was a sheet named "D". It is better to include your
formula in the body of the message and not just in the subject.

Regards.

--
 

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 and If statement help 1
Adding ISERROR to formula 3
Finding dynamic maxima 8
Vlook-up in report with column Expansion 5
Vlookups to return a N/A value 3
Vlookup issue 2
vlookup 1
vlookup for mutiple rows 6

Back
Top