Vlookup help required

[smiler44]

Please can you help me with Vlookup.

I understand this formula =IF(ISNA(VLOOKUP(C4,A2:B3,2,FALSE))=TRUE,"ABC",VLOOKUP(C4,A2:B3,2,FALSE))
to some degree.

I now need to add another aspect to the above formula, if C4 is blank but E4 has the letter B in it,
I need Back Order to be displayed where I have my formula but I have no idea how.

Please could you show me?

Thank you in advance

smiler44

 

[Brianwarnock]

I think that just requires an additional if test, something like

If(and(isblank("c4"),"e4"="B"),"Back order", now your Vlookup if

Brian

 

[smiler44]

I think that just requires an additional if test, something like

If(and(isblank("c4"),"e4"="B"),"Back order", now your Vlookup if

Brian

Brian, thank you for a quick reply, I have put my VLookup formula but without the = after your last comma. It seems that only my part of the formula is being actioned and your part of the formula is being ignored. Please could you tell me what I am doing wrong, thank you. Smiler44

 

[smiler44]

Brian, I've removed the speech marks from e4 in the formula which I think is the right thing to do. But I'm getting a #value! Error. Smiler44

 

[smiler44]

Brian, I've removed the speech marks from e4 in the formula which I think is the right thing to do. But I'm getting a #value! Error. Smiler44

Ha got it not sure if I got it in error or not I h removed speech marks from cs and e4 thank you brian I would not have got it without you. Smiler44

 

[Brianwarnock]

Damn, Ive been so used to writing Range("A1") stuff in VBA that I automatically put the "" in , glad you sorted it.

Brian

 

[smiler44]

I wish my fingers and brain were connected.
should have said I have removed speech marks from c4 and e4.
Thanks again Brian.
Smiler44