Forum Discussion
Piece
You can use the VLOOKUP function to find a piece in an Excel table with a value. The syntax of the VLOOKUP function is as follows:
=VLOOKUP(Lookup_Value,Table_Array,Col_Index_Num,Range_Lookup)
- Lookup_Value: The value you want to look up in the first column of the table.
- Table_Array: The range of cells that contains the table. The first column of the range must contain the lookup value.
- Col_Index_Num: The column number in the table from which to return a value. The first column is 1.
- Range_Lookup: A logical value that specifies whether you want an exact match or an approximate match. Enter FALSE for an exact match or TRUE for an approximate match.
For example, if you want to find a piece called “X” in a table named “Y” with values in columns A and B, you can use the following formula:
=VLOOKUP("X",Y!A:B,2,FALSE)
This formula looks up “X” in column A of the table named “Y” and returns the corresponding value from column B.
But when it comes to value labeling...
Can label a cell with text by right-clicking the cell and selecting "Format Cell". Click on the "Numbers" tab and select "Custom".
In the Type field, enter the following text:
Default "Piece". or whatever lettering you like.
Click on OK to save the changes .
I hope this helps!