vlookups and if statement

[excelrookie]

I am doing a simple vlookup, but need to search another column and if I find
a match change the lookup result.
example
vlookup(a2,tab1a2:b50,3). if A3 = 25, then I need to change the lookup value
to reflect the if statement result.
Any help would be appreciated

 

[smartin]

I am doing a simple vlookup, but need to search another column and if I find
a match change the lookup result.
example
vlookup(a2,tab1a2:b50,3). if A3 = 25, then I need to change the lookup value
to reflect the if statement result.
Any help would be appreciated

What IF statement, and what is A3?

=iF(vlookup(a2,tab1a2:b50,3)=25, [alternate lookup], [something else])

?

 

[Bob Bridges]

While you're answering smartin's very relevant questions, allow me to point
out that the sample formula you typed out for us won't work. Even assumping
an extra bang ("!"), like this:

VLOOKUP(A2,Tab1!A2:B50,3)

....the third argument says to take a value from the third column, yet you
specified only a two-column table. In my version of Excel, at least, this
returns the #REF error.

What IF statement, and what is A3?

=iF(vlookup(a2,tab1a2:b50,3)=25, [alternate lookup], [something else])

I am doing a simple vlookup, but need to search another column and if I find
a match change the lookup result. example:

vlookup(a2,tab1a2:b50,3).

if A3 = 25, then I need to change the lookup value to reflect the if
statement result.

 

[smartin]

While you're answering smartin's very relevant questions, allow me to point
out that the sample formula you typed out for us won't work. Even assumping
an extra bang ("!"), like this:

VLOOKUP(A2,Tab1!A2:B50,3)

...the third argument says to take a value from the third column, yet you
specified only a two-column table. In my version of Excel, at least, this
returns the #REF error.

Bob, Thanks for looking over my overlooking the obvious (^: