Multiple lookup values

[syparth]

Hello,
I have multiple lookup values. how to use with vlookup or any other option ?
Eg. Search/Compare value1 in ColumnA , value2 in Column B and value3 in Column C , and if these three value matches in a perticular row , then return the value from the column D.

Is there any specific function for the same ?
Thanking you in advance.

[FDibbins]

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[stusic]

I am very interested in this topic, so I'm attaching an example workbook to keep the ball rolling.

This workbook has 3 values (AB1:AB3) which need to be cross-referenced against the table at AC9:AL13 (finding the first value that's greater than AB1), then return the value in Col AB that's on the same row as the referenced value. In the example workbook, the correct tonnage is 132, and the Cell that would be returned is AB12.

Thank You,

[FDibbins]

Hi stusic

2 things...

1st, you didnt attach a file

2nd Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

[stusic]

Hi stusic

2 things...

1st, you didnt attach a file

2nd Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Thanks, done.