Trying to combine an if statement & a dual vlookup...its doing something but....

Hi,

I am trying to combine an if statement, with a dual vlookup...

What I am trying to get a result for is: If a cell in sheet 1 has a "yes" value, then lookup that name & type with a value on sheet 2 which is in sheet 3...

I know that it is doing something correct as cells that have a "yes" in is coming up n/a but cells which are blank are coming up false.

This is my formula any help is very much appreciated: (PS I am a novice, please be nice and try to explain as simple as possible)

=IF(Games!B6="YES",VLOOKUP(Games!A6,'Appearance Fees'!$A$4:$P$100,MATCH('Amounts '!B5,'Appearance Fees'!$B$2:$P$100,0)+1,0))

Thanks

forgot my value if false... so now the formula looks like this:

=IF(Games!E17="YES",VLOOKUP(Games!D17,'Appearance Fees'!$A$4:$P$100,MATCH('Amounts '!E16,'Appearance Fees'!$B$2:$P$100,0)+1,0)," ")

and I no longer get the 'false' just the n/a where I should have a figure returned from the lookup part of the formula

Ahh, almost posted about the FALSE value.

Are you able to provide a sample of your work or can you create one that we can see the data?

N/A is a result of the VLOOKUP erroring out.

Hi, I am not able to provide what i'm working on or the actual data - but have tried to put something similar together with Dummy Data.

There are 3 sheets, and on sheet 3 I need it to return the relevant values.

It has to match the persons name & type (B,D,L)

Its actually a lot more complicated, but highly confidential & no one I work with has barely any excel knowledge at all...

In your sample workbook, if you put this formula in B3 and drag down/right it will return what you want. It uses a an index with 2 match formulas nested inside. Let me know if you have any questions.

=IF(INDEX(Sheet2!$B$2:$D$9,MATCH(Sheet3!$A3,Sheet2!$A$2:$A$9,0),MATCH(Sheet3!B$2,Sheet2!$B$1:$D$1,0))="YES",INDEX(Sheet1!$B$2:$D$9,MATCH(Sheet3!$A3,Sheet1!$A$2:$A$9,0),MATCH(Sheet3!B$2,Sheet1!$B$1:$D$1,0)),"")