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

excelrookie wrote:
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])

?

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.

--- "smartin" wrote:
What IF statement, and what is A3?

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

--- excelrookie wrote:
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.

Bob Bridges wrote:
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 (^: