Hello,
I am trying to work out a formula that will search through multiple sheets. If information is entered into 'G2', this formula would look for corresponding data throughout the sheets and place the results.
The formula below is what I have thus far. It seems to stop at the first match and goes no further. Due to security at my job, I can not utilize a macro or attach an example of the worksheet.
Code
=IFERROR(VLOOKUP(G2,'Sheet1'!A5:D124,4,TRUE),IFERROR(VLOOKUP(G21,'Sheet2'!A3:D120,4,TRUE),IFERROR(VLOOKUP(G2,'Sheet3'!A4:D120,4,TRUE),"N/A")))
Please let me know if any additional information is needed. Thank you for the help!