Alphacsulb
03-25-2008, 04:16 PM
Hello Guys,
This spreedsheet is driving me nuts. Here is my problem:
Row eleven starting at G uses this formula:
=HLOOKUP(I10,$G$3:$AB$4,2)
Pretty much what the formula says, or atleast hope it says is "Look at cell I10, if the figure in I10 matches a cell in the array G3 through AB4 then put down the figure that is below the matching one.
Row 12 is a simple if two cells match then True, if not False.
Anyways, as you can see from the picture I have the same formula in row 11, cells G11 and H11 match but I11 does not. It has the same word as I3 but is pulling the information as if it was matching to the cell in G3.
Help!!!! http://www.mrexcel.com/forum/images/smilies/confused.gif
http://i88.photobucket.com/albums/k193/Rgarcia9/2c54f309.jpg
This spreedsheet is driving me nuts. Here is my problem:
Row eleven starting at G uses this formula:
=HLOOKUP(I10,$G$3:$AB$4,2)
Pretty much what the formula says, or atleast hope it says is "Look at cell I10, if the figure in I10 matches a cell in the array G3 through AB4 then put down the figure that is below the matching one.
Row 12 is a simple if two cells match then True, if not False.
Anyways, as you can see from the picture I have the same formula in row 11, cells G11 and H11 match but I11 does not. It has the same word as I3 but is pulling the information as if it was matching to the cell in G3.
Help!!!! http://www.mrexcel.com/forum/images/smilies/confused.gif
http://i88.photobucket.com/albums/k193/Rgarcia9/2c54f309.jpg