Formula to lookup multiple Criteria

[eRalph]

Hi all
I am looking for a Formula that would solve a problem like this:

=IF(BASE!BI:BI,1,LOOKUP(DAILY!G2,BASE!D:D,BASE!AV:AV

So I want to search for the value in DAILY!G2 in BASE!D:D and if found return the appropriate value from BASE!AV:AV to CELL BJ2 in DAILY!
ie If the IF requirement is also satisfied.

Hope this makes sense.

ps.. just for my own learning curve I think this may be an IF, INDEX, MATCH type formula?

Regards
Ralph

 

[Special-K99]

Either the forum has corrupted your post or you have not completed the formula correctly.
The formula as it is would certainly throw up an error (no closing brackets for a start)

You may have < > characters in your description, the forum may not show them correctly.
Surround any < > characters with spaces and your post should show up properly.

Until then we can't read what the remainder of your IF statement says