If or formula

S

Susan

Trying to create a formula that will do the following:

If a1="1", then vlookup ...........or if A1="2" then vlookup......
 
G

Gord Dibben

Not enough information.

Vlookup what?

Where would this formula be entered?

Let's say for example we had Gord in B1

In C1 we enter =IF(A1=1,VLOOKUP(B1,table,colndx,false),"not equal 1")


Gord Dibben MS Excel MVP
 
J

John

Maybe this ; =IF(OR(A1=1,A1=2),vlookup,"")
This is just a example : =IF(OR(A1=1,A1=2),VLOOKUP(B1,C1:D12,2,FALSE),"")
You don't say what you want if no match, so I put "", this will leave the cell
blank.
If you put double quotes around your numbers, it will tell excel that those
numbers are text, not numbers.
HTH
John
 

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

Excel - Wich Function should I use? 1
Help With VLOOKUP 2
Copy a formula using Vlookup 2
Code works on sheet but not from code-to-sheet 2
vlookup with numbers 10
excel formula is returning incorrect values 0
=IF(ISNA(VLOOKUP(A1,Data!$B$1:$C$200,MATCH(A1,Data!$A$1:$C$1,IF($V 3
IF statement with multiple VLOOKUPs 0

Top