So the value you have in A3 is for sure found in range A3:A922 of the Job Sheet?
Is so, check for accuracy. Spelling, extra spaces, numbers formatted as Text....
The formula looks good if you want to extract value from A3:A922.. which would be the same value that is in A3 of the Quotations sheet... if you want to get column B info, replace the 1 with a 2.
Bookmarks