If B1 in sheet 1 matches a cell in column A of sheet 2 then return the column E of that matching row in sheet 2.
Formula input would be in cell P2 of sheet 1 -> IF B2 (Sheet 1) = A2:A1826 (any value in that range of sheet 2) then return C(matching row number sheet 2)
See what I'm saying? Hard to explain sorry haha
You're contradicting yourself and it doesn't match with your original post. Please clarify:
[1] The name of the sheet that contains the lookup table. Excel normally creates "Sheet2" but you're suggesting it's "Sheet 2". Does it really have the space?
[2] The column the contains the value to search for. Originally you said column A but now you've changed that to column B. Which is it?
[3] In which column you want to put the result of the lookup. Originally I'd assumed column B but now that's potentially the column that contains the value to search for.
[4] The column on "Sheet2"/"Sheet 2" that contains the value you want to return. Your original post said column C but you changed it to column E and then back to column C in the above.
This is a simple VLOOKUP you're looking for but your requirements are not clear at all. Posting sample data would make it much much easier.
WBD