Look up two criteria and return one value

Closed

officemanager - Apr 17, 2010 at 01:01 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 17, 2010 at 02:01 PM

Hi

I'm trying to do a vlookup to look up a PO number in a 2nd spreadsheet which contains the sage output of PO number / amount / invoice no/ date and

In spreadsheet A look up PO number and invoice amount (in separate columns) and then return the corresponding value from spreadsheet 2.

Any ideas

Look up two criteria and return one value
Display two columns in data validation list but return only one - Guide
If cell contains date then return value ✓ - Excel Forum
Zuma return - Download - Puzzle
Excel formula to check if cell contains a date - Excel Forum
Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 17, 2010 at 02:01 PM

Most easy and efficient way would be to add a working column to combine the two column in the lookup table

then you can use lookup as for example

=vlookup(A2 & B2, sheet2!A:f, 5, true)

Similar discussions

Excel - IF function with multiple words

WOW equipment return

If a cell contains any text then add a value

If cell = date return yes or no.

Excel: If Date =, then enter a value

Similar discussions

Subscribe To Our Newsletter!