I have a spreadsheet that has data in a column of cells that have both
numbers and letters (ABCD 123456) that shoud match data in one of two tabs in
the same worksheet. What I'm trying to do is have a forumla look at the
information in the first tab match it to the same matching information in the
other tabs and depending on which of the two tabs in finds the information in
will return a answer. I've been playing with the vlookup and can get a
formula to look at one sheet and return the right answer, but I can't get a
formula to look at both sheets and return the right answer.