If or formula

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

Trying to create a formula that will do the following:

If a1="1", then vlookup ...........or if A1="2" then vlookup......
 
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
 
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
 
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

Excel IF statement with vlookup 2
EXCEL - IF(IFERROR(VLOOKUP question 0
=IF(ISNA(VLOOKUP(A1,Data!$B$1:$C$200,MATCH(A1,Data!$A$1:$C$1,IF($V 3
Need help in Combining If formula with Vlookup 2
Copy a formula using Vlookup 2
create a formula by using text from other cells 1
Multiple columns using Vlookup 3
tab name 7

Back
Top