vlookup formula

[Mark Horsfall]

Hello

I want a formula for cell C4

This is what I want to have in the formula

If C3 says "Test A" lookup F3 If C3 says "Test B" lookup G3 If C3 says "Test A" lookup H3

Can you help

Mark

 

[Khalid NGO]

Hi Mark,
You have already made your logic, you just need to implement it with IFs:
=IF(C3="Test A",F3,IF(C3="Test B",G3,H3))

Why you have mentioned 2 different lookups for Test A?

Regards,

 

[Mark Horsfall]

The second test a should be test C

Thanks

 

[Khalid NGO]

The second test a should be test C

Thanks

It will work same as you required, but if you want another test, add another IF:
=IF(C3="Test A",F3,IF(C3="Test B",G3,IF(C3="Test C",H3,"")))

Or use this:
=LOOKUP(C3,{"Test A","Test B","Test C"},F3:H3)

Regards,