ExcelBanter - Looking for Excel function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Looking for Excel function (https://www.excelbanter.com/excel-worksheet-functions/75885-looking-excel-function.html)

Looking for Excel function

Hi all,

Would like to find out how to do I use the Excel built-in functions to
- compare following item A (Col A) & B columns data (Col C), if found matching, further comparing their Qty data
-Qty B (Col D) could be less than Qty A (Col B)
- thus display the result in new column with values eg, "Qty matched", "Less Qty", "Item A not found" in Col E

item A Qty A item B Qty B
BBF345 1248 BBF345 1248
BGF378 1255 BGF378 1255
HCZ733 1206 HCZ733 1206
HCZ123 1241 HCZ123 1241
HCZ267 1256 HCZ267 1256
HJP300 1258 HJP300 1250
HUP005 1258 HUP005 1258
TRY001 1260 TRY001 1260
HIT888 1259 HIT888 1208
GOOD33 1259 GOOD33 1235
WHY099 1234 WHY099 1178
AAA876 1006

thanks.

Looking for Excel function

Hi

When you search for match on same row, then
IF(A2=C2,IF(D2<B2,"Less Qty",IF(D2B2,"???","Qty matched")),"Item " & A2 & "
not found")

--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )