without a sample, this is difficult. Usually you need to have your data formatted in a certain way for the vlookup or hlookup to be effective. For example, if you have a table with data in cells c1:e3 (a 3x3 table) and you want to check to see if the value of a1 is located and pull a piece of data that corresponds and insert this into b1, the formula would be (located in cell b1):
if the value of a1 was located somewhere within the c1:e1 cells, the lookup would pull whatever piece of data was located in the 3rd cell down.
is this what you were looking for or am i off base?
Bookmarks