0

Using excel. I have this sample data (There's > 28,000 rows, just got a 7 row sample size)

enter image description here

I am using this formula =VLOOKUP(new_q.csv!$A$67&new_q.csv!$B$67, A2:B28563, 4, FALSE) to try to match find a match in the above data, using the data source below new_q.csv. (The data is filtered, which is why I'm using A67, and B67 respectively)

enter image description here

Clearly row 2 in new_q.csv matches data from row 1 in the top data. Not only do I get a !REF, but before that reference error I received #N/A which can't be right, because the cell values match.

Any thoughts? Thanks

nick_rinaldi
  • 641
  • 6
  • 17
  • With vlookup the entire lookup needs to be in the left most column. You are looking for a string like: `9780544106644105` in column A in the other sheet. Then the second issue is that the range in the second criterion only has two columns but you are trying to refer to the 4th. The third criterion is the relative column of the range in the second to return. – Scott Craner Sep 21 '21 at 20:57
  • Thanks, this helped clear things up. Basically I'm trying to query a combination of cell values together, like A:67&B:67. For this case, do I make the lookup in the entire left column, still? – nick_rinaldi Sep 21 '21 at 21:29
  • if you want to use VLOOKUP, But since you are returning numbers SUMIFS should work if the combination of isbn and date are unique. There are many ways to do this, look at the link above. It goes through many different methods. – Scott Craner Sep 21 '21 at 21:33

0 Answers0