Gesyca_is_joy
Board Regular
- Joined
- Apr 24, 2014
- Messages
- 90
- Office Version
- 365
- Platform
- Windows
I am trying to write a VLOOKUP on "SHEET2" to pull information from a table on SHEET1 (See below).
The table in SHEET one is called "PriceLog" my formula looks like this: =VLOOKUP(C2,PriceLog,9,0)
Cell C2 in this formula is a cell that has a formula itself to return the lowest value per certain criteria. that cell is currently displaying the value $1.67
But everytime I put in that formula I get #N/A as the result. I would attach the file to this but I cannot attach anything for some reason.
Category SubCategory Note Qty Size Price Coupon/ Sale Unit Price Store Date
Baking Cake Mix 3 Each 5.00 $1.67 Sam's Club 30-Aug-15
Baking Cake Mix 1 Each 4.98 $4.98 Kroger's 30-Aug-15
Baking Cake Mix 1 Each 3.25 Yes $3.25 Wal-Mart
Also when I try to put a table in this post all I see is the code for the table not the table itself so I am sorry if the spacing on my sheet example is off. Thank you.
The table in SHEET one is called "PriceLog" my formula looks like this: =VLOOKUP(C2,PriceLog,9,0)
Cell C2 in this formula is a cell that has a formula itself to return the lowest value per certain criteria. that cell is currently displaying the value $1.67
But everytime I put in that formula I get #N/A as the result. I would attach the file to this but I cannot attach anything for some reason.
Category SubCategory Note Qty Size Price Coupon/ Sale Unit Price Store Date
Baking Cake Mix 3 Each 5.00 $1.67 Sam's Club 30-Aug-15
Baking Cake Mix 1 Each 4.98 $4.98 Kroger's 30-Aug-15
Baking Cake Mix 1 Each 3.25 Yes $3.25 Wal-Mart
Also when I try to put a table in this post all I see is the code for the table not the table itself so I am sorry if the spacing on my sheet example is off. Thank you.