Vlookup to return specific value if cell value of vlookup is specific

Hi all

...Having one of those days....

I need to have a vlookup and if statement I believe....

In need to vlookup and if the cell value to be returned is 'active' I would like "A" returned instead... and if is not equal to 'active', then blank

TIA

Shaz0503

If(vlookupstatement="active","A","")

soberguy....

Thank you so much - I was nearly there myself - just left out the '=' ....

rgds

Happy to help. If you'd be so kind as to mark the thread solved, that would be most excellent.

soberguy

just a quick question, if I want to include additional values what should I use = eg active OR inactive

I tried =IF(VLOOKUP(A4,AM_Weekly!C:D,2,)={"Active","Inactive"},"A") but returns "false"

S

Haven't really tried that before, but it would probably look like:
=IF(OR(VLOOKUP(A4,AM_Weekly!C:D,2,)="Active",VLOOKUP(A4,AM_Weekly!C:D,2,)="Inactive"),"A")

Soberguy

=IF(OR(VLOOKUP(A4,AM_Weekly!C:D,2,)="Active",VLOOKUP(A4,AM_Weekly!C:D,2,)="Inactive"),"A","")

works perfectly,,,,

rgds

Thanks Tony,,

Will keep that one also...

sometimes it is so easy when its right in front of you...

shaz0503