Forum Discussion
Auto-populate a cell with the contains from another cell
stephurso In te file I sent you the formula would become:
=IFERROR(VLOOKUP(B2,Parts,2,FALSE),"")
See attached.
Hello: Riny_van_Eekelen
This worked great! I used the VLOOKUP formula. Just one question. When there is no part number in B2, C2 displays #N/A. Is there a way to suppress that so it's just blank until someone actually puts in a part number into B2?
- Like this? =IFERROR(VLOOKUP(B2,Parts,2,FALSE)
I keep getting an error message.stephurso In te file I sent you the formula would become:
=IFERROR(VLOOKUP(B2,Parts,2,FALSE),"")
See attached.
Hello. I have a spreadsheet that records fueling info for a truck company. It contains 3 columns of data, such as Vehicle #, Gallons, Date. note: I am actually currently using an excel to re-arange the data in this required order shown in attached photo.
The file is downloaded from the fuel recorder once per day. It contains different quantity of rows each day. Example today may have been 20 rows of data, tomorrow 35 rows. There is no static data in any cell.
I now need to add 3 additional columns of State (KY), Location (LOT) and City (Nashville). This will be static data. My issue is that this data only needs to populate down to where the entries end. As I said, they end in different rows each day. Example: If the file only contains data down to row 20, then my 3 new static fields should not populate past 20.
I need a formular or excel script to look at the cell to the left and if its populated with any data, then add the 3 static fields. If not populated, leave blank.
Thanks
Randy
