ExcelBanter - Vlookup

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Vlookup (https://www.excelbanter.com/new-users-excel/233329-vlookup.html)

HS[_2_]

Vlookup

is it possible to do a vlookup only if the column prior is tagged with a Y

so far example

If Column J says Y then Column K does the lookup?
=IF(J3=Y,Vlookup(Data!A2:H1602,8,false)

except this doesn't work

T. Valko

Vlookup

Is this what you meant?

=IF(J3="Y",VLOOKUP(K3,Data!A2:H1602,8,0),"")

--
Biff
Microsoft Excel MVP

"HS" wrote in message
...
is it possible to do a vlookup only if the column prior is tagged with a Y

so far example

If Column J says Y then Column K does the lookup?
=IF(J3=Y,Vlookup(Data!A2:H1602,8,false)

except this doesn't work

HS[_2_]

Vlookup

this is great, thank you!! :)

"HS" wrote:

is it possible to do a vlookup only if the column prior is tagged with a Y

so far example

If Column J says Y then Column K does the lookup?
=IF(J3=Y,Vlookup(Data!A2:H1602,8,false)

except this doesn't work

All times are GMT +1. The time now is 09:53 AM.