Forum Discussion

Copper Contributor

Jan 03, 2023

Solved

vlookup error with multiple criteria

Hi, I have a spreadsheet with a list of training courses individuals have completed and the date, which is a connected export of a sharepoint list. I have another spreadsheet with is the training...

excel

Formulas and Functions

Rodrigo_
Jan 03, 2023
TSimsD

It will return error or #N/A to your formula, because your lookup value and doesn't match on your reference table.
Just change your "combinedname" on your export sheet without including the title of training.
Formula: [@[First Name]&@[Surname]]

Rodrigo_

Iron Contributor

Jan 03, 2023

TSimsD

It will return error or #N/A to your formula, because your lookup value and doesn't match on your reference table.
Just change your "combinedname" on your export sheet without including the title of training.
Formula: [@[First Name]&@[Surname]]

TSimsD

Copper Contributor

Jan 03, 2023

Rodrigo_

Thanks rrstrivera,

the formula is correct. As I said it works on other courses. The lookup is the combined first name & surname coupled with the title of the training.

Formula: =IFERROR(VLOOKUP([@Combinedname]&Table32[[#Headers],[Manual Handling]],'Exported List from Training Register.xlsx'!Table_query__32[[#All],[Combinedname]:[Date completed]],8,FALSE),"")

Cheers

Tony

Rodrigo_
Iron Contributor
Jan 05, 2023

Hi, TSimsD
Since we solved it on thru PM, there's a link to mark the solution at the bottom.
This helps for those who search.

Thanks!
- TSimsD
  Copper Contributor
  Jan 05, 2023
  Hi I can't see a link