# Lookup Formula for multiple cells with multiple results

1. ## Lookup Formula for multiple cells with multiple results

If E16 is Male and H16 is over 18 but under 30 then insert whatever number is in R6
However if E16 is Male and H16 is over 30 but under 40 then insert whatever number is in R11
However is E16 is Female and H16 is over 18 but under 30 then insert whatever number is in R31
However is E16 is Female and H16 is over 30 but under 40 then insert whatever number is in R36
There’s about 6 other variations but if you could please write out the entire code covering all 4 variations above I can take it from there. THANK U!!!

2. ## Re: Lookup Formula for multiple cells with multiple results

Maybe this series of IF statements:

``Please Login or Register  to view this content.``
Just as a heads-up, I added an equal sign before 30 so that it is caught in one of the categories.

Hope this helps.

abousetta

3. ## Re: Lookup Formula for multiple cells with multiple results

Hi CKD777

I think you should look at the Vlookup function with a TRUE for the last argument. See
http://www.excelfunctions.net/ExcelVlookup.html

4. ## Re: Lookup Formula for multiple cells with multiple results

I noticed some mistakes in the formula I posted. I have corrected them. Just thought I would let you know to discard the earlier formula.

abousetta

5. ## Re: Lookup Formula for multiple cells with multiple results

Originally Posted by abousetta
Maybe this series of IF statements:

``Please Login or Register  to view this content.``
Just as a heads-up, I added an equal sign before 30 so that it is caught in one of the categories.

Hope this helps.

abousetta
Thanx for the effort. Still didn't work, but I appreciate you trying to help

6. ## Re: Lookup Formula for multiple cells with multiple results

If you attach a sample workbook it is much easier to solve this problem.

Click on "Go Advanced" below the message area and then on the Paper Clip Icon above the advanced message area to attach a file.

There are currently 1 users browsing this thread. (0 members and 1 guests)