I have two spreadsheets, File A has 3 cols of numbers that I am trying to use
as a cross reference that has two columns of possibilites into File B. What I
would like to be able to do is have a vlookup created in File B that says to
go to File A col A and find a match, when you find the match look in col C.
If number is there then pull into File B, if empty go to col B to pull into
File B.