How to lookup criteria in two columns

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hi

thanks for getting back to me. I think my brain may be a little frazzled but I could not get it to work.

Also I may not have explained what I was trying to do very clearly. Here is a very simplified extraction from the sheets I am using

spreadsheet 1
PO expected cost Result
14373 26.37 [actual cost should appear here]
14365 40.99 [actual cost should appear here]
14365 24.5 [actual cost should appear here]


spreadsheet 2
PO invoice no desciption actual cost
14365 71337 40275 27221 Goods 24.08
14365 71312 40274 27220 Goods 40.99
14373 E45040 40274 27323 gifts 26.37

I basically want to get the actual cost from sheet 2 into sheet 1 but having checked that it corresponds with col a and b in sheet 1.

Also do they have to be formatted as text or as numbers - doesnt A1&A2 usually concatenate numbers and add them together? In which case here it will bring back the wrong result. I need to leave everything as numbers for other formulea in the spreadsheet to work.

Any ideas would be really appreciated.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
How column B is involved ? in you example, there is PO only on sheet 1, which appears on sheet 2 also. in column A. If you meant look at PO and cost from sheet 1 , then there is again no new cost to look for ?