Mixing an IF with a vlookup twice?

[Weaselwithagun]

Hi folks,

I'm trying to use this formula;

=IF(G4="",IFNA(VLOOKUP(P4,Data!A:B,2,0),""))

For this purpose:

Each line that is entered MUST complete the relevant cell in column P then column O performs the lookup and gives the required info.

(unfortunately columns can't be moved or added to in this sheet)

But I only want column 0 to perform the lookup if there is no data in column G.

the above formula kinda works, but it displays 'False' if there is data in column G (i'm guessing the logic rule implies that this answer must either be true or false?)

How would i change the formula to only perform the lookup in column O if column G is blank?

As always any assistance is greatly appreciated.

Cheers.

[Richard Buttrey]

Hi,

One way

=IF(G4<>"","",VLOOKUP(P4,Data!A:B,2,0))

[JohnTopley]

Misread post!

[TMS]

=IF(G4="",IFNA(VLOOKUP(P4,Data!A:B,2,0),""),"")