I have a single list of values (we'll call it A:A) that I need to find
where they exist in another worksheet (Sheet2A:IV).

Obviously, if I do a Vlookup (or Hlookup), it'll only look in row A on
Sheet2 for my specified value. Is there a formula that will look in
all cells, in Sheet2, for a specific record in Sheet1?

Thanks for your help!!!