VLOOKUP

R

Robert Lowe

Hello,
Can someone please help me with VLOOKUP.

C10 format is GENERAL contains 2323
Montreal!column B format is TEXT

B10 format is TEXT contains
=+VLOOKUP(CONCATENATE($C$10,"9"),Montreal!$B:$O,2,FALSE)
returns #N/A (value not available error)

Thank you
Robert
 

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

Same forumula returns both 0 & N/A 2
Searching the formula (not the value) for a text string 1
Vlookup 1
combine three if functions 3
If equation with a VLookUp 3
VLOOKUP source values are a formula result. Getting #N/A 7
vlookup returns na 7
Multiple VLOOKUP in an IF statement 2

Top