Vlookup Help needed

[dwhite30518]

Hello everyone,

I need some help. I can't seem to find the correct formula to retrieve the data I want. I have 2 spreadsheets. One is named "Picked Report" and the other is named "CheckIn". I want to pull the data from column K in the Picked report to the respective record on the Checkin worksheet. I need to look up the the Order number(which is common ID factor in both worksheets) and Item Number/Name (which is also on both sheets). So I need a formula that will look up the order number and then the item number and if those match, then retrieve the data point in column K. I am trying to capture this data point in column D of the Checkin worksheet.

What is the best way to do this?

I have attached a copy of the data sets for your assistance.

Thanks!!!!!

[hrlngrv]

The first match appears to be in row 572 in CheckIn. If the formula should be in E572,

=INDEX('Picked Report'!K$2:K$3859,MATCH(TRUE,IF('Picked Report'!$B$2:$B$3859=A572,'Picked Report'!$F$2:$F$3859=B572),0))

This is an array formula, so type it, then hold down [Ctrl] and [Shift] keys before pressing [Enter].

[FDibbins]

It would have been helpful if you used th same headings in each sheet, as well as in your text above. Order number is fine, but I see no Item number/name on either sheet...assume that to be INV ITEM NAME (sht1) and PaerNumber (sht2)?

That being said, try this regular formula in F2, copied down...
=IFERROR(INDEX('Picked Report'!$K$2:$K$3859,MATCH(CheckIn!A2&" "&CheckIn!B2,INDEX('Picked Report'!$B$2:$B$3859&" "&'Picked Report'!$F$2:$F$3859,0),0)),"")
1st match appears in row 139, then 572 onwards

[dwhite30518]

FDibbins...that formula worked great! Thanks!

[FDibbins]

Happy to help