VLOOKUP with different cells/tab

Hi guys,

I have a tab called: MAIN SHEET with interviewers details (interview no, first name, surname etc.), on this sheet I also have Q1, Q2, Q3, Q4 (which represents 4 quarters and if they were targeted for their performance in those quarters).

Data for Q1, Q2, Q3 and Q4 will come from different tabs in the same work book called (Q1_Summary, Q2_Summary etc.) can someone tell me what formula I should write to retrieve whether the interviewer was targeted in the relevant quarters?

Main sheet:
CELL A3: Int no. B3: FirstName C3: Surname

Q1_Summary: H3 has Y (yes) or N (no) under 'Targeted?'

Many thanks guys!

Post a sample spreadsheet with expected results, remove any sensitive data, create a mockup example if necessary.
Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.

Spreadsheet attached

In Q1_SuMMARY H3 is blank (neither Y nor N).
L3:O3 is the Targeted? range

Try

In MAIN SHEET!K4
=VLOOKUP(A4,Q1_Summary!$A$3:$O$20,12,0)

For the other columns adjust the name of the sheet Q2_SUMMARY, Q3_SUMMARY etc (assuming the formats are the same).

NOTE: Am note sure why you have Targeted in H2 as targeted is also in L2:O2 ?
Or why there's only one column targeted for Q1 - no Targeted for other quarters ?

perfect thanks Special K!

All good here.

I am working through some quarters individually and them on a whole too. Thanks again